SELECT a.*,b.`company_logo`,b.`company_url` FROM `tbl_employer_job` a LEFT JOIN `tbl_employers` b ON a.employer_id=b.employer_id WHERE 1=1 AND a.`is_delete`='Inactive' AND a.`status`='Active' AND a.`expiry_date` >= CURRENT_DATE() AND (`min_sal` BETWEEN Not Specified AND Not Specified) AND (`max_sal` BETWEEN Not Specified AND Not Specified) ORDER BY a.`membership_type` ASC,a.`job_id` DESC
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Not Specified AND Not Specified) AND (`max_sal` BETWEEN Not Specified AND Not S' at line 3